﻿CREATE PROCEDURE [Restaurant].[SP_DeliverySiteDeliveryMode_U]
	@DeliverySiteID int, 
	@DeliveryModeType varchar(20),
	@IsDeliveryCheckAvailable bit,
	@IsCheckInRequired bit,
	@IsRemotePrintRequired bit,
	@RemotePrinterName nvarchar(200),
	@IsDefault bit
AS
	UPDATE [Restaurant].[DeliverySiteDeliveryMode]
	SET
		IsDeliveryCheckAvailable = @IsDeliveryCheckAvailable,
		IsCheckInRequired = @IsCheckInRequired,
		IsRemotePrintRequired = @IsRemotePrintRequired,
		RemotePrinterName = @RemotePrinterName,
		IsDefault = @IsDefault
	WHERE
		DeliverySiteID = @DeliverySiteID AND DeliveryModeType = @DeliveryModeType
RETURN 0